Análisis Exploratorio y Descriptivo Interactivo

Dataset statistics

Number of variables	29
Number of observations	24786
Missing cells	9563
Missing cells (%)	1.3%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	5.5 MiB
Average record size in memory	232.0 B

Variable types

Numeric	17
Categorical	12

Alerts

`categoria` is highly imbalanced (82.1%)	Imbalance
`garantia` is highly imbalanced (82.7%)	Imbalance
`forma_de_pago` is highly imbalanced (59.0%)	Imbalance
`reestructurado` is highly imbalanced (98.9%)	Imbalance
`ocupacion` is highly imbalanced (62.5%)	Imbalance
`tipo_contrato` is highly imbalanced (68.1%)	Imbalance
`clase` is highly imbalanced (86.9%)	Imbalance
`tipo_vivienda` has 4372 (17.6%) missing values	Missing
`tipo_contrato` has 5191 (20.9%) missing values	Missing
`cedula` is uniformly distributed	Uniform
`cedula` has unique values	Unique
`tiempo_desembolso` has 1102 (4.4%) zeros	Zeros
`diasmora` has 15060 (60.8%) zeros	Zeros
`egreso_total` has 4683 (18.9%) zeros	Zeros
`antiguedad_empresa` has 5554 (22.4%) zeros	Zeros
`personas` has 9305 (37.5%) zeros	Zeros
`aportes` has 3128 (12.6%) zeros	Zeros
`antiguedad_entidad` has 418 (1.7%) zeros	Zeros

Reproduction

Analysis started	2024-03-12 12:38:07.996614
Analysis finished	2024-03-12 12:39:05.218559
Duration	57.22 seconds
Software version	ydata-profiling vv4.6.5
Download configuration	config.json

cedula
Real number (ℝ)

UNIFORM UNIQUE

Distinct	24786
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12393.5

Minimum	1
Maximum	24786
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	193.8 KiB

Quantile statistics

Minimum	1
5-th percentile	1240.25
Q1	6197.25
median	12393.5
Q3	18589.75
95-th percentile	23546.75
Maximum	24786
Range	24785
Interquartile range (IQR)	12392.5

Descriptive statistics

Standard deviation	7155.2462
Coefficient of variation (CV)	0.57733862
Kurtosis	-1.2
Mean	12393.5
Median Absolute Deviation (MAD)	6196.5
Skewness	2.7536731 × 10^-17
Sum	3.0718529 × 10⁸
Variance	51197548
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6754	1	< 0.1%
13535	1	< 0.1%
13573	1	< 0.1%
13577	1	< 0.1%
13578	1	< 0.1%
13579	1	< 0.1%
13580	1	< 0.1%
13581	1	< 0.1%
13582	1	< 0.1%
13583	1	< 0.1%
Other values (24776)	24776	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%
10	1	< 0.1%

Value	Count	Frequency (%)
24786	1	< 0.1%
24785	1	< 0.1%
24784	1	< 0.1%
24783	1	< 0.1%
24782	1	< 0.1%
24781	1	< 0.1%
24780	1	< 0.1%
24779	1	< 0.1%
24778	1	< 0.1%
24777	1	< 0.1%

oficina
Categorical

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	193.8 KiB

Santa Fe	4977
Chapinero	4720
Usme	3660
San Cristóbal	3090
Usaquen	2488
Other values (4)	5851

Length

Max length	13
Median length	9
Mean length	7.8997821
Min length	4

Characters and Unicode

Total characters	195804
Distinct characters	27
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Santa Fe
2nd row	Usaquen
3rd row	Chapinero
4th row	Santa Fe
5th row	Chapinero

Common Values

Value	Count	Frequency (%)
Santa Fe	4977	20.1%
Chapinero	4720	19.0%
Usme	3660	14.8%
San Cristóbal	3090	12.5%
Usaquen	2488	10.0%
Tunjuelito	1937	7.8%
Kennedy	1597	6.4%
Tunal	1465	5.9%
Bosa	852	3.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
santa	4977	15.1%
fe	4977	15.1%
chapinero	4720	14.4%
usme	3660	11.1%
san	3090	9.4%
cristóbal	3090	9.4%
usaquen	2488	7.6%
tunjuelito	1937	5.9%
kennedy	1597	4.9%
tunal	1465	4.5%

Most occurring characters

Value	Count	Frequency (%)
a	25659	13.1%
n	21871	11.2%
e	20976	10.7%
s	10090	5.2%
t	10004	5.1%
i	9747	5.0%
S	8067	4.1%
	8067	4.1%
u	7827	4.0%
C	7810	4.0%
Other values (17)	65686	33.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	154884	79.1%
Uppercase Letter	32853	16.8%
Space Separator	8067	4.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	25659	16.6%
n	21871	14.1%
e	20976	13.5%
s	10090	6.5%
t	10004	6.5%
i	9747	6.3%
u	7827	5.1%
r	7810	5.0%
o	7509	4.8%
l	6492	4.2%
Other values (9)	26899	17.4%

Uppercase Letter

Value	Count	Frequency (%)
S	8067	24.6%
C	7810	23.8%
U	6148	18.7%
F	4977	15.1%
T	3402	10.4%
K	1597	4.9%
B	852	2.6%

Space Separator

Value	Count	Frequency (%)
	8067	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	187737	95.9%
Common	8067	4.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	25659	13.7%
n	21871	11.6%
e	20976	11.2%
s	10090	5.4%
t	10004	5.3%
i	9747	5.2%
S	8067	4.3%
u	7827	4.2%
C	7810	4.2%
r	7810	4.2%
Other values (16)	57876	30.8%

Common

Value	Count	Frequency (%)
	8067	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	192714	98.4%
None	3090	1.6%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	25659	13.3%
n	21871	11.3%
e	20976	10.9%
s	10090	5.2%
t	10004	5.2%
i	9747	5.1%
S	8067	4.2%
	8067	4.2%
u	7827	4.1%
C	7810	4.1%
Other values (16)	62596	32.5%

None

Value	Count	Frequency (%)
ó	3090	100.0%

categoria
Categorical

IMBALANCE

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	193.8 KiB

A	23332
B	843
E	304
C	162
D	145

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	24786
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	E
2nd row	E
3rd row	E
4th row	E
5th row	E

Common Values

Value	Count	Frequency (%)
A	23332	94.1%
B	843	3.4%
E	304	1.2%
C	162	0.7%
D	145	0.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
a	23332	94.1%
b	843	3.4%
e	304	1.2%
c	162	0.7%
d	145	0.6%

Most occurring characters

Value	Count	Frequency (%)
A	23332	94.1%
B	843	3.4%
E	304	1.2%
C	162	0.7%
D	145	0.6%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	24786	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	23332	94.1%
B	843	3.4%
E	304	1.2%
C	162	0.7%
D	145	0.6%

Most occurring scripts

Value	Count	Frequency (%)
Latin	24786	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	23332	94.1%
B	843	3.4%
E	304	1.2%
C	162	0.7%
D	145	0.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	24786	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	23332	94.1%
B	843	3.4%
E	304	1.2%
C	162	0.7%
D	145	0.6%

tiempo_desembolso
Real number (ℝ)

ZEROS

Distinct	67
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.5409909

Minimum	-11
Maximum	68
Zeros	1102
Zeros (%)	4.4%
Negative	1
Negative (%)	< 0.1%
Memory size	193.8 KiB

Quantile statistics

Minimum	-11
5-th percentile	1
Q1	3
median	8
Q3	14
95-th percentile	23
Maximum	68
Range	79
Interquartile range (IQR)	11

Descriptive statistics

Standard deviation	8.1048327
Coefficient of variation (CV)	0.84947495
Kurtosis	6.2701694
Mean	9.5409909
Median Absolute Deviation (MAD)	5
Skewness	1.8086797
Sum	236483
Variance	65.688314
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	1768	7.1%
5	1740	7.0%
3	1722	6.9%
1	1633	6.6%
4	1526	6.2%
6	1424	5.7%
8	1352	5.5%
7	1271	5.1%
9	1216	4.9%
0	1102	4.4%
Other values (57)	10032	40.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-11	1	< 0.1%
0	1102	4.4%
1	1633	6.6%
2	1768	7.1%
3	1722	6.9%
4	1526	6.2%
5	1740	7.0%
6	1424	5.7%
7	1271	5.1%
8	1352	5.5%

Value	Count	Frequency (%)
68	1	< 0.1%
67	4	< 0.1%
66	1	< 0.1%
65	4	< 0.1%
64	3	< 0.1%
63	3	< 0.1%
62	4	< 0.1%
61	9	< 0.1%
60	15	0.1%
59	7	< 0.1%

monto
Real number (ℝ)

Distinct	645
Distinct (%)	2.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3213142

Minimum	101083
Maximum	61800000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	193.8 KiB

Quantile statistics

Minimum	101083
5-th percentile	800000
Q1	1500000
median	2500000
Q3	4000000
95-th percentile	8000000
Maximum	61800000
Range	61698917
Interquartile range (IQR)	2500000

Descriptive statistics

Standard deviation	3052970.7
Coefficient of variation (CV)	0.95015118
Kurtosis	56.979316
Mean	3213142
Median Absolute Deviation (MAD)	1000000
Skewness	5.3728547
Sum	7.9640938 × 10¹⁰
Variance	9.3206298 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2000000	3313	13.4%
3000000	2342	9.4%
1000000	1888	7.6%
1500000	1808	7.3%
4000000	1503	6.1%
2500000	1488	6.0%
5000000	1292	5.2%
6000000	720	2.9%
3500000	706	2.8%
1200000	608	2.5%
Other values (635)	9118	36.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
101083	1	< 0.1%
139347	1	< 0.1%
146792	1	< 0.1%
191143	1	< 0.1%
219687	1	< 0.1%
232719	1	< 0.1%
237054	1	< 0.1%
241834	1	< 0.1%
277069	1	< 0.1%
277967	1	< 0.1%

Value	Count	Frequency (%)
61800000	1	< 0.1%
61000000	1	< 0.1%
57000000	1	< 0.1%
52000000	4	< 0.1%
50000000	2	< 0.1%
45000000	5	< 0.1%
44000000	1	< 0.1%
42000000	1	< 0.1%
40000000	2	< 0.1%
39510444	1	< 0.1%

saldo
Real number (ℝ)

Distinct	12659
Distinct (%)	51.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2380017.4

Minimum	19
Maximum	59312409
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	193.8 KiB

Quantile statistics

Minimum	19
5-th percentile	275344.5
Q1	876867
median	1669316.5
Q3	2960204.8
95-th percentile	6744576
Maximum	59312409
Range	59312390
Interquartile range (IQR)	2083337.8

Descriptive statistics

Standard deviation	2641900.3
Coefficient of variation (CV)	1.110034
Kurtosis	52.303771
Mean	2380017.4
Median Absolute Deviation (MAD)	955031.5
Skewness	5.0301935
Sum	5.8991112 × 10¹⁰
Variance	6.9796372 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2000000	160	0.6%
1000000	122	0.5%
1500000	114	0.5%
1935679	106	0.4%
3000000	100	0.4%
1870044	88	0.4%
1803306	72	0.3%
954047	66	0.3%
2829846	60	0.2%
2887422	56	0.2%
Other values (12649)	23842	96.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
19	1	< 0.1%
35	1	< 0.1%
2941	1	< 0.1%
6801	1	< 0.1%
8757	1	< 0.1%
12426	1	< 0.1%
26932	1	< 0.1%
28168	1	< 0.1%
38870	1	< 0.1%
42242	1	< 0.1%

Value	Count	Frequency (%)
59312409	1	< 0.1%
56549783	1	< 0.1%
48112641	1	< 0.1%
45530067	1	< 0.1%
42782716	1	< 0.1%
39717871	1	< 0.1%
38734501	1	< 0.1%
38505226	1	< 0.1%
37525257	1	< 0.1%
36171750	1	< 0.1%

plazo
Real number (ℝ)

Distinct	84
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	28.003591

Minimum	2
Maximum	180
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	193.8 KiB

Quantile statistics

Minimum	2
5-th percentile	15
Q1	18
median	24
Q3	36
95-th percentile	48
Maximum	180
Range	178
Interquartile range (IQR)	18

Descriptive statistics

Standard deviation	11.567857
Coefficient of variation (CV)	0.41308478
Kurtosis	12.924694
Mean	28.003591
Median Absolute Deviation (MAD)	6
Skewness	2.0375796
Sum	694097
Variance	133.81532
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
24	5605	22.6%
36	5458	22.0%
18	3715	15.0%
30	2254	9.1%
15	1694	6.8%
48	1643	6.6%
12	1072	4.3%
21	766	3.1%
27	681	2.7%
33	491	2.0%
Other values (74)	1407	5.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	4	< 0.1%
3	2	< 0.1%
4	3	< 0.1%
5	1	< 0.1%
6	32	0.1%
7	8	< 0.1%
8	27	0.1%
9	12	< 0.1%
10	42	0.2%
11	6	< 0.1%

Value	Count	Frequency (%)
180	4	< 0.1%
144	1	< 0.1%
125	1	< 0.1%
120	39	0.2%
112	1	< 0.1%
108	2	< 0.1%
105	1	< 0.1%
103	1	< 0.1%
96	7	< 0.1%
94	1	< 0.1%

tasa
Real number (ℝ)

Distinct	61
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.1714661

Minimum	0.1625
Maximum	3.3
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	193.8 KiB

Quantile statistics

Minimum	0.1625
5-th percentile	2.17
Q1	2.1742
median	2.1742
Q3	2.1742
95-th percentile	2.1742
Maximum	3.3
Range	3.1375
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.065143665
Coefficient of variation (CV)	0.029999853
Kurtosis	239.25723
Mean	2.1714661
Median Absolute Deviation (MAD)	0
Skewness	0.46037458
Sum	53821.959
Variance	0.0042436971
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2.1742	23066	93.1%
2.17	578	2.3%
2	219	0.9%
2.18	211	0.9%
2.0833	84	0.3%
1.95	78	0.3%
2.1867	68	0.3%
2.02	67	0.3%
2.1217	62	0.3%
2.0834	47	0.2%
Other values (51)	306	1.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.1625	1	< 0.1%
0.5	1	< 0.1%
1	15	0.1%
1.5	22	0.1%
1.8133	1	< 0.1%
1.95	78	0.3%
1.9725	27	0.1%
1.9783	46	0.2%
2	219	0.9%
2.02	67	0.3%

Value	Count	Frequency (%)
3.3	18	0.1%
3.25	5	< 0.1%
3.2083	2	< 0.1%
3.1667	5	< 0.1%
3.15	4	< 0.1%
2.95	3	< 0.1%
2.9083	1	< 0.1%
2.875	1	< 0.1%
2.85	1	< 0.1%
2.8333	1	< 0.1%

cuota
Real number (ℝ)

Distinct	8313
Distinct (%)	33.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	145241.79

Minimum	22247
Maximum	2080188
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	193.8 KiB

Quantile statistics

Minimum	22247
5-th percentile	60988
Q1	95181
median	121054
Q3	164076.25
95-th percentile	298228
Maximum	2080188
Range	2057941
Interquartile range (IQR)	68895.25

Descriptive statistics

Standard deviation	94230.521
Coefficient of variation (CV)	0.64878379
Kurtosis	50.265431
Mean	145241.79
Median Absolute Deviation (MAD)	35926.5
Skewness	4.8353305
Sum	3.5999631 × 10⁹
Variance	8.8793912 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
107849	134	0.5%
107899	131	0.5%
107842	129	0.5%
108441	114	0.5%
108754	97	0.4%
107877	97	0.4%
67765	97	0.4%
121054	87	0.4%
107840	83	0.3%
107898	82	0.3%
Other values (8303)	23735	95.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
22247	1	< 0.1%
26312	1	< 0.1%
28682	1	< 0.1%
28689	1	< 0.1%
28690	1	< 0.1%
28719	1	< 0.1%
30183	1	< 0.1%
30357	1	< 0.1%
30504	1	< 0.1%
31723	1	< 0.1%

Value	Count	Frequency (%)
2080188	1	< 0.1%
1887469	1	< 0.1%
1821775	1	< 0.1%
1743432	1	< 0.1%
1713100	1	< 0.1%
1657846	1	< 0.1%
1488098	1	< 0.1%
1430866	1	< 0.1%
1415445	1	< 0.1%
1376580	1	< 0.1%

garantia
Categorical

IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	193.8 KiB

P	24145
R	641

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	24786
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	P
2nd row	P
3rd row	P
4th row	P
5th row	R

Common Values

Value	Count	Frequency (%)
P	24145	97.4%
R	641	2.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
p	24145	97.4%
r	641	2.6%

Most occurring characters

Value	Count	Frequency (%)
P	24145	97.4%
R	641	2.6%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	24786	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
P	24145	97.4%
R	641	2.6%

Most occurring scripts

Value	Count	Frequency (%)
Latin	24786	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
P	24145	97.4%
R	641	2.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	24786	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
P	24145	97.4%
R	641	2.6%

diasmora
Real number (ℝ)

ZEROS

Distinct	402
Distinct (%)	1.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	13.893367

Minimum	0
Maximum	1784
Zeros	15060
Zeros (%)	60.8%
Negative	0
Negative (%)	0.0%
Memory size	193.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	10
95-th percentile	40
Maximum	1784
Range	1784
Interquartile range (IQR)	10

Descriptive statistics

Standard deviation	71.817455
Coefficient of variation (CV)	5.16919
Kurtosis	203.7449
Mean	13.893367
Median Absolute Deviation (MAD)	0
Skewness	12.824392
Sum	344361
Variance	5157.7469
Monotonicity	Decreasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	15060	60.8%
4	587	2.4%
5	528	2.1%
2	453	1.8%
3	442	1.8%
10	384	1.5%
9	383	1.5%
8	371	1.5%
7	365	1.5%
6	343	1.4%
Other values (392)	5870	23.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	15060	60.8%
1	1	< 0.1%
2	453	1.8%
3	442	1.8%
4	587	2.4%
5	528	2.1%
6	343	1.4%
7	365	1.5%
8	371	1.5%
9	383	1.5%

Value	Count	Frequency (%)
1784	1	< 0.1%
1758	1	< 0.1%
1677	1	< 0.1%
1670	1	< 0.1%
1621	1	< 0.1%
1587	1	< 0.1%
1440	1	< 0.1%
1424	1	< 0.1%
1416	1	< 0.1%
1407	1	< 0.1%

forma_de_pago
Categorical

IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	193.8 KiB

1	22747
2	2039

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	24786
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	22747	91.8%
2	2039	8.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	22747	91.8%
2	2039	8.2%

Most occurring characters

Value	Count	Frequency (%)
1	22747	91.8%
2	2039	8.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	24786	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	22747	91.8%
2	2039	8.2%

Most occurring scripts

Value	Count	Frequency (%)
Common	24786	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	22747	91.8%
2	2039	8.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	24786	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	22747	91.8%
2	2039	8.2%

reestructurado
Categorical

IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	193.8 KiB

2	24761
1	25

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	24786
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2
2nd row	2
3rd row	2
4th row	2
5th row	2

Common Values

Value	Count	Frequency (%)
2	24761	99.9%
1	25	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2	24761	99.9%
1	25	0.1%

Most occurring characters

Value	Count	Frequency (%)
2	24761	99.9%
1	25	0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	24786	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	24761	99.9%
1	25	0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	24786	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	24761	99.9%
1	25	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	24786	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	24761	99.9%
1	25	0.1%

edad
Real number (ℝ)

Distinct	61
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	41.081941

Minimum	19
Maximum	83
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	193.8 KiB

Quantile statistics

Minimum	19
5-th percentile	25
Q1	32
median	40
Q3	49
95-th percentile	62
Maximum	83
Range	64
Interquartile range (IQR)	17

Descriptive statistics

Standard deviation	11.147799
Coefficient of variation (CV)	0.27135521
Kurtosis	-0.54128261
Mean	41.081941
Median Absolute Deviation (MAD)	8
Skewness	0.43378159
Sum	1018257
Variance	124.27341
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
38	916	3.7%
35	905	3.7%
37	869	3.5%
36	847	3.4%
39	839	3.4%
33	818	3.3%
34	803	3.2%
41	799	3.2%
31	787	3.2%
40	777	3.1%
Other values (51)	16426	66.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
19	1	< 0.1%
20	27	0.1%
21	94	0.4%
22	173	0.7%
23	287	1.2%
24	359	1.4%
25	504	2.0%
26	549	2.2%
27	647	2.6%
28	705	2.8%

Value	Count	Frequency (%)
83	1	< 0.1%
80	1	< 0.1%
77	1	< 0.1%
76	1	< 0.1%
75	3	< 0.1%
74	6	< 0.1%
73	3	< 0.1%
72	15	0.1%
71	24	0.1%
70	39	0.2%

ocupacion
Categorical

IMBALANCE

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	193.8 KiB

Empleado	19788
Jubilado	2285
Independiente	2034
Pensionado	383
Desempleado	222
Other values (2)	74

Length

Max length	13
Median length	8
Mean length	8.4769225
Min length	8

Characters and Unicode

Total characters	210109
Distinct characters	21
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Empleado
2nd row	Empleado
3rd row	Empleado
4th row	Empleado
5th row	Independiente

Common Values

Value	Count	Frequency (%)
Empleado	19788	79.8%
Jubilado	2285	9.2%
Independiente	2034	8.2%
Pensionado	383	1.5%
Desempleado	222	0.9%
Ama de Casa	71	0.3%
Estudiante	3	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
empleado	19788	79.4%
jubilado	2285	9.2%
independiente	2034	8.2%
pensionado	383	1.5%
desempleado	222	0.9%
ama	71	0.3%
de	71	0.3%
casa	71	0.3%
estudiante	3	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
e	29047	13.8%
d	26820	12.8%
o	23061	11.0%
a	22894	10.9%
l	22295	10.6%
p	22044	10.5%
m	20081	9.6%
E	19791	9.4%
n	6871	3.3%
i	4705	2.2%
Other values (11)	12500	5.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	185110	88.1%
Uppercase Letter	24857	11.8%
Space Separator	142	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	29047	15.7%
d	26820	14.5%
o	23061	12.5%
a	22894	12.4%
l	22295	12.0%
p	22044	11.9%
m	20081	10.8%
n	6871	3.7%
i	4705	2.5%
u	2288	1.2%
Other values (3)	5004	2.7%

Uppercase Letter

Value	Count	Frequency (%)
E	19791	79.6%
J	2285	9.2%
I	2034	8.2%
P	383	1.5%
D	222	0.9%
A	71	0.3%
C	71	0.3%

Space Separator

Value	Count	Frequency (%)
	142	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	209967	99.9%
Common	142	0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	29047	13.8%
d	26820	12.8%
o	23061	11.0%
a	22894	10.9%
l	22295	10.6%
p	22044	10.5%
m	20081	9.6%
E	19791	9.4%
n	6871	3.3%
i	4705	2.2%
Other values (10)	12358	5.9%

Common

Value	Count	Frequency (%)
	142	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	210109	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	29047	13.8%
d	26820	12.8%
o	23061	11.0%
a	22894	10.9%
l	22295	10.6%
p	22044	10.5%
m	20081	9.6%
E	19791	9.4%
n	6871	3.3%
i	4705	2.2%
Other values (11)	12500	5.9%

nivel_educativo
Categorical

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	193.8 KiB

Bachillerato	11686
Universitario	4726
Tecnológico	4590
Primaria	3368
Técnico	262
Other values (2)	154

Length

Max length	13
Median length	12
Mean length	11.37852
Min length	7

Characters and Unicode

Total characters	282028
Distinct characters	23
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Bachillerato
2nd row	Bachillerato
3rd row	Técnico
4th row	Bachillerato
5th row	Universitario

Common Values

Value	Count	Frequency (%)
Bachillerato	11686	47.1%
Universitario	4726	19.1%
Tecnológico	4590	18.5%
Primaria	3368	13.6%
Técnico	262	1.1%
Ninguno	148	0.6%
Postgrado	6	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
bachillerato	11686	47.1%
universitario	4726	19.1%
tecnológico	4590	18.5%
primaria	3368	13.6%
técnico	262	1.1%
ninguno	148	0.6%
postgrado	6	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
i	37600	13.3%
a	34840	12.4%
l	27962	9.9%
r	27880	9.9%
o	26014	9.2%
c	21390	7.6%
e	21002	7.4%
t	16418	5.8%
B	11686	4.1%
h	11686	4.1%
Other values (13)	45550	16.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	257242	91.2%
Uppercase Letter	24786	8.8%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	37600	14.6%
a	34840	13.5%
l	27962	10.9%
r	27880	10.8%
o	26014	10.1%
c	21390	8.3%
e	21002	8.2%
t	16418	6.4%
h	11686	4.5%
n	9874	3.8%
Other values (8)	22576	8.8%

Uppercase Letter

Value	Count	Frequency (%)
B	11686	47.1%
T	4852	19.6%
U	4726	19.1%
P	3374	13.6%
N	148	0.6%

Most occurring scripts

Value	Count	Frequency (%)
Latin	282028	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	37600	13.3%
a	34840	12.4%
l	27962	9.9%
r	27880	9.9%
o	26014	9.2%
c	21390	7.6%
e	21002	7.4%
t	16418	5.8%
B	11686	4.1%
h	11686	4.1%
Other values (13)	45550	16.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	277176	98.3%
None	4852	1.7%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
i	37600	13.6%
a	34840	12.6%
l	27962	10.1%
r	27880	10.1%
o	26014	9.4%
c	21390	7.7%
e	21002	7.6%
t	16418	5.9%
B	11686	4.2%
h	11686	4.2%
Other values (11)	40698	14.7%

None

Value	Count	Frequency (%)
ó	4590	94.6%
é	262	5.4%

ingreso_total
Real number (ℝ)

Distinct	7936
Distinct (%)	32.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1068714.5

Minimum	0
Maximum	15100000
Zeros	238
Zeros (%)	1.0%
Negative	0
Negative (%)	0.0%
Memory size	193.8 KiB

Quantile statistics

Minimum	0
5-th percentile	380000
Q1	600000
median	863982
Q3	1285000
95-th percentile	2446600
Maximum	15100000
Range	15100000
Interquartile range (IQR)	685000

Descriptive statistics

Standard deviation	785496.91
Coefficient of variation (CV)	0.73499227
Kurtosis	31.470932
Mean	1068714.5
Median Absolute Deviation (MAD)	313982
Skewness	3.8626758
Sum	2.6489158 × 10¹⁰
Variance	6.170054 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
600000	519	2.1%
1200000	510	2.1%
800000	508	2.0%
700000	423	1.7%
1500000	416	1.7%
1000000	415	1.7%
900000	330	1.3%
500000	323	1.3%
1300000	272	1.1%
1100000	268	1.1%
Other values (7926)	20802	83.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	238	1.0%
1	18	0.1%
100	1	< 0.1%
1000	1	< 0.1%
20000	2	< 0.1%
50000	6	< 0.1%
60000	1	< 0.1%
80000	2	< 0.1%
82000	1	< 0.1%
100000	21	0.1%

Value	Count	Frequency (%)
15100000	1	< 0.1%
15000000	1	< 0.1%
13200000	1	< 0.1%
12300000	1	< 0.1%
12250000	1	< 0.1%
12000000	1	< 0.1%
10614000	1	< 0.1%
10500000	1	< 0.1%
10000000	2	< 0.1%
9900000	1	< 0.1%

egreso_total
Real number (ℝ)

ZEROS

Distinct	1867
Distinct (%)	7.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	360320.26

Minimum	0
Maximum	11800000
Zeros	4683
Zeros (%)	18.9%
Negative	0
Negative (%)	0.0%
Memory size	193.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	120000
median	300000
Q3	500000
95-th percentile	1000000
Maximum	11800000
Range	11800000
Interquartile range (IQR)	380000

Descriptive statistics

Standard deviation	407422.84
Coefficient of variation (CV)	1.1307242
Kurtosis	73.721673
Mean	360320.26
Median Absolute Deviation (MAD)	192000
Skewness	5.3154815
Sum	8.9308981 × 10⁹
Variance	1.6599337 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4683	18.9%
200000	1699	6.9%
300000	1662	6.7%
400000	994	4.0%
150000	989	4.0%
250000	943	3.8%
500000	912	3.7%
100000	827	3.3%
350000	632	2.5%
600000	619	2.5%
Other values (1857)	10826	43.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4683	18.9%
1	16	0.1%
100	1	< 0.1%
1000	1	< 0.1%
20000	2	< 0.1%
25000	1	< 0.1%
30000	10	< 0.1%
32000	1	< 0.1%
38000	2	< 0.1%
40000	6	< 0.1%

Value	Count	Frequency (%)
11800000	1	< 0.1%
10000000	1	< 0.1%
8150000	1	< 0.1%
8000000	1	< 0.1%
7000000	1	< 0.1%
6200000	1	< 0.1%
6180000	1	< 0.1%
6000000	1	< 0.1%
5500000	2	< 0.1%
5300000	1	< 0.1%

estrato
Real number (ℝ)

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.816711

Minimum	0
Maximum	6
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	193.8 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	2
median	3
Q3	3
95-th percentile	4
Maximum	6
Range	6
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.79818026
Coefficient of variation (CV)	0.28337314
Kurtosis	1.3351731
Mean	2.816711
Median Absolute Deviation (MAD)	0
Skewness	0.6143378
Sum	69815
Variance	0.63709172
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
3	13222	53.3%
2	7612	30.7%
4	2444	9.9%
5	778	3.1%
1	623	2.5%
6	106	0.4%
0	1	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	623	2.5%
2	7612	30.7%
3	13222	53.3%
4	2444	9.9%
5	778	3.1%
6	106	0.4%

Value	Count	Frequency (%)
6	106	0.4%
5	778	3.1%
4	2444	9.9%
3	13222	53.3%
2	7612	30.7%
1	623	2.5%
0	1	< 0.1%

antiguedad_empresa
Real number (ℝ)

ZEROS

Distinct	48
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.7613976

Minimum	-1
Maximum	46
Zeros	5554
Zeros (%)	22.4%
Negative	61
Negative (%)	0.2%
Memory size	193.8 KiB

Quantile statistics

Minimum	-1
5-th percentile	0
Q1	1
median	6
Q3	11
95-th percentile	26
Maximum	46
Range	47
Interquartile range (IQR)	10

Descriptive statistics

Standard deviation	8.0802384
Coefficient of variation (CV)	1.0410803
Kurtosis	1.408668
Mean	7.7613976
Median Absolute Deviation (MAD)	5
Skewness	1.3334429
Sum	192374
Variance	65.290252
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=48)

Value	Count	Frequency (%)
0	5554	22.4%
3	1567	6.3%
5	1432	5.8%
2	1407	5.7%
4	1401	5.7%
8	1312	5.3%
6	1273	5.1%
7	1254	5.1%
9	1084	4.4%
11	876	3.5%
Other values (38)	7626	30.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-1	61	0.2%
0	5554	22.4%
1	824	3.3%
2	1407	5.7%
3	1567	6.3%
4	1401	5.7%
5	1432	5.8%
6	1273	5.1%
7	1254	5.1%
8	1312	5.3%

Value	Count	Frequency (%)
46	1	< 0.1%
45	1	< 0.1%
44	2	< 0.1%
43	2	< 0.1%
42	5	< 0.1%
41	5	< 0.1%
40	8	< 0.1%
39	8	< 0.1%
38	13	0.1%
37	25	0.1%

estado_civil
Categorical

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	193.8 KiB

Casado	12135
Soltero	7601
Unión Libre	2150
Separado	1701
Viudo	1189

Length

Max length	12
Median length	11
Mean length	6.8320826
Min length	5

Characters and Unicode

Total characters	169340
Distinct characters	23
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Unión Libre
2nd row	Soltero
3rd row	Soltero
4th row	Casado
5th row	Casado

Common Values

Value	Count	Frequency (%)
Casado	12135	49.0%
Soltero	7601	30.7%
Unión Libre	2150	8.7%
Separado	1701	6.9%
Viudo	1189	4.8%
Eclesiástico	10	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
casado	12135	45.1%
soltero	7601	28.2%
unión	2150	8.0%
libre	2150	8.0%
separado	1701	6.3%
viudo	1189	4.4%
eclesiástico	10	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
o	30237	17.9%
a	27672	16.3%
d	15025	8.9%
s	12155	7.2%
C	12135	7.2%
e	11462	6.8%
r	11452	6.8%
S	9302	5.5%
l	7611	4.5%
t	7611	4.5%
Other values (13)	24678	14.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	140254	82.8%
Uppercase Letter	26936	15.9%
Space Separator	2150	1.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	30237	21.6%
a	27672	19.7%
d	15025	10.7%
s	12155	8.7%
e	11462	8.2%
r	11452	8.2%
l	7611	5.4%
t	7611	5.4%
i	5509	3.9%
n	4300	3.1%
Other values (6)	7220	5.1%

Uppercase Letter

Value	Count	Frequency (%)
C	12135	45.1%
S	9302	34.5%
U	2150	8.0%
L	2150	8.0%
V	1189	4.4%
E	10	< 0.1%

Space Separator

Value	Count	Frequency (%)
	2150	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	167190	98.7%
Common	2150	1.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	30237	18.1%
a	27672	16.6%
d	15025	9.0%
s	12155	7.3%
C	12135	7.3%
e	11462	6.9%
r	11452	6.8%
S	9302	5.6%
l	7611	4.6%
t	7611	4.6%
Other values (12)	22528	13.5%

Common

Value	Count	Frequency (%)
	2150	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	167180	98.7%
None	2160	1.3%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	30237	18.1%
a	27672	16.6%
d	15025	9.0%
s	12155	7.3%
C	12135	7.3%
e	11462	6.9%
r	11452	6.9%
S	9302	5.6%
l	7611	4.6%
t	7611	4.6%
Other values (11)	22518	13.5%

None

Value	Count	Frequency (%)
ó	2150	99.5%
á	10	0.5%

sexo
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	193.8 KiB

Masculino	12500
Femenino	12286

Length

Max length	9
Median length	9
Mean length	8.504317
Min length	8

Characters and Unicode

Total characters	210788
Distinct characters	12
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Masculino
2nd row	Masculino
3rd row	Femenino
4th row	Masculino
5th row	Masculino

Common Values

Value	Count	Frequency (%)
Masculino	12500	50.4%
Femenino	12286	49.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
masculino	12500	50.4%
femenino	12286	49.6%

Most occurring characters

Value	Count	Frequency (%)
n	37072	17.6%
i	24786	11.8%
o	24786	11.8%
e	24572	11.7%
M	12500	5.9%
a	12500	5.9%
s	12500	5.9%
c	12500	5.9%
u	12500	5.9%
l	12500	5.9%
Other values (2)	24572	11.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	186002	88.2%
Uppercase Letter	24786	11.8%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
n	37072	19.9%
i	24786	13.3%
o	24786	13.3%
e	24572	13.2%
a	12500	6.7%
s	12500	6.7%
c	12500	6.7%
u	12500	6.7%
l	12500	6.7%
m	12286	6.6%

Uppercase Letter

Value	Count	Frequency (%)
M	12500	50.4%
F	12286	49.6%

Most occurring scripts

Value	Count	Frequency (%)
Latin	210788	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
n	37072	17.6%
i	24786	11.8%
o	24786	11.8%
e	24572	11.7%
M	12500	5.9%
a	12500	5.9%
s	12500	5.9%
c	12500	5.9%
u	12500	5.9%
l	12500	5.9%
Other values (2)	24572	11.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	210788	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
n	37072	17.6%
i	24786	11.8%
o	24786	11.8%
e	24572	11.7%
M	12500	5.9%
a	12500	5.9%
s	12500	5.9%
c	12500	5.9%
u	12500	5.9%
l	12500	5.9%
Other values (2)	24572	11.7%

personas
Real number (ℝ)

ZEROS

Distinct	10
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.2311789

Minimum	0
Maximum	25
Zeros	9305
Zeros (%)	37.5%
Negative	0
Negative (%)	0.0%
Memory size	193.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	2
95-th percentile	3
Maximum	25
Range	25
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.237067
Coefficient of variation (CV)	1.0047825
Kurtosis	5.38155
Mean	1.2311789
Median Absolute Deviation (MAD)	1
Skewness	1.0346785
Sum	30516
Variance	1.5303347
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	9305	37.5%
1	5965	24.1%
2	5368	21.7%
3	3076	12.4%
4	841	3.4%
5	191	0.8%
6	31	0.1%
7	7	< 0.1%
25	1	< 0.1%
8	1	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	9305	37.5%
1	5965	24.1%
2	5368	21.7%
3	3076	12.4%
4	841	3.4%
5	191	0.8%
6	31	0.1%
7	7	< 0.1%
8	1	< 0.1%
25	1	< 0.1%

Value	Count	Frequency (%)
25	1	< 0.1%
8	1	< 0.1%
7	7	< 0.1%
6	31	0.1%
5	191	0.8%
4	841	3.4%
3	3076	12.4%
2	5368	21.7%
1	5965	24.1%
0	9305	37.5%

tipo_vivienda
Categorical

MISSING

Distinct	3
Distinct (%)	< 0.1%
Missing	4372
Missing (%)	17.6%
Memory size	193.8 KiB

Propia	10326
Familiar	6366
Arrendada	3722

Length

Max length	9
Median length	6
Mean length	7.1706672
Min length	6

Characters and Unicode

Total characters	146382
Distinct characters	13
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Familiar
2nd row	Propia
3rd row	Familiar
4th row	Familiar
5th row	Familiar

Common Values

Value	Count	Frequency (%)
Propia	10326	41.7%
Familiar	6366	25.7%
Arrendada	3722	15.0%
(Missing)	4372	17.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
propia	10326	50.6%
familiar	6366	31.2%
arrendada	3722	18.2%

Most occurring characters

Value	Count	Frequency (%)
a	30502	20.8%
r	24136	16.5%
i	23058	15.8%
P	10326	7.1%
o	10326	7.1%
p	10326	7.1%
d	7444	5.1%
F	6366	4.3%
m	6366	4.3%
l	6366	4.3%
Other values (3)	11166	7.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	125968	86.1%
Uppercase Letter	20414	13.9%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	30502	24.2%
r	24136	19.2%
i	23058	18.3%
o	10326	8.2%
p	10326	8.2%
d	7444	5.9%
m	6366	5.1%
l	6366	5.1%
e	3722	3.0%
n	3722	3.0%

Uppercase Letter

Value	Count	Frequency (%)
P	10326	50.6%
F	6366	31.2%
A	3722	18.2%

Most occurring scripts

Value	Count	Frequency (%)
Latin	146382	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	30502	20.8%
r	24136	16.5%
i	23058	15.8%
P	10326	7.1%
o	10326	7.1%
p	10326	7.1%
d	7444	5.1%
F	6366	4.3%
m	6366	4.3%
l	6366	4.3%
Other values (3)	11166	7.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	146382	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	30502	20.8%
r	24136	16.5%
i	23058	15.8%
P	10326	7.1%
o	10326	7.1%
p	10326	7.1%
d	7444	5.1%
F	6366	4.3%
m	6366	4.3%
l	6366	4.3%
Other values (3)	11166	7.6%

tipo_contrato
Categorical

IMBALANCE MISSING

Distinct	4
Distinct (%)	< 0.1%
Missing	5191
Missing (%)	20.9%
Memory size	193.8 KiB

Término Indefinido	17061
Término Definido	2234
Servicios	157
Jubilados	143

Length

Max length	18
Median length	18
Mean length	17.634192
Min length	9

Characters and Unicode

Total characters	345542
Distinct characters	22
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Término Indefinido
2nd row	Término Indefinido
3rd row	Término Indefinido
4th row	Término Indefinido
5th row	Término Indefinido

Common Values

Value	Count	Frequency (%)
Término Indefinido	17061	68.8%
Término Definido	2234	9.0%
Servicios	157	0.6%
Jubilados	143	0.6%
(Missing)	5191	20.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
término	19295	49.6%
indefinido	17061	43.9%
definido	2234	5.7%
servicios	157	0.4%
jubilados	143	0.4%

Most occurring characters

Value	Count	Frequency (%)
i	58342	16.9%
n	55651	16.1%
o	38890	11.3%
d	36499	10.6%
r	19452	5.6%
e	19452	5.6%
T	19295	5.6%
é	19295	5.6%
f	19295	5.6%
	19295	5.6%
Other values (12)	40076	11.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	287357	83.2%
Uppercase Letter	38890	11.3%
Space Separator	19295	5.6%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	58342	20.3%
n	55651	19.4%
o	38890	13.5%
d	36499	12.7%
r	19452	6.8%
e	19452	6.8%
é	19295	6.7%
f	19295	6.7%
m	19295	6.7%
s	300	0.1%
Other values (6)	886	0.3%

Uppercase Letter

Value	Count	Frequency (%)
T	19295	49.6%
I	17061	43.9%
D	2234	5.7%
S	157	0.4%
J	143	0.4%

Space Separator

Value	Count	Frequency (%)
	19295	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	326247	94.4%
Common	19295	5.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	58342	17.9%
n	55651	17.1%
o	38890	11.9%
d	36499	11.2%
r	19452	6.0%
e	19452	6.0%
T	19295	5.9%
é	19295	5.9%
f	19295	5.9%
m	19295	5.9%
Other values (11)	20781	6.4%

Common

Value	Count	Frequency (%)
	19295	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	326247	94.4%
None	19295	5.6%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
i	58342	17.9%
n	55651	17.1%
o	38890	11.9%
d	36499	11.2%
r	19452	6.0%
e	19452	6.0%
T	19295	5.9%
f	19295	5.9%
	19295	5.9%
m	19295	5.9%
Other values (11)	20781	6.4%

None

Value	Count	Frequency (%)
é	19295	100.0%

aportes
Real number (ℝ)

ZEROS

Distinct	819
Distinct (%)	3.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	84506.373

Minimum	0
Maximum	1463000
Zeros	3128
Zeros (%)	12.6%
Negative	0
Negative (%)	0.0%
Memory size	193.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	15500
median	31000
Q3	155000
95-th percentile	212500
Maximum	1463000
Range	1463000
Interquartile range (IQR)	139500

Descriptive statistics

Standard deviation	96940.637
Coefficient of variation (CV)	1.14714
Kurtosis	12.968855
Mean	84506.373
Median Absolute Deviation (MAD)	31000
Skewness	2.2477617
Sum	2.094575 × 10⁹
Variance	9.3974871 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
15500	4629	18.7%
0	3128	12.6%
155000	1600	6.5%
6000	1396	5.6%
16000	1092	4.4%
170000	968	3.9%
21500	827	3.3%
166000	798	3.2%
131000	773	3.1%
143000	628	2.5%
Other values (809)	8947	36.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3128	12.6%
6000	1396	5.6%
7000	74	0.3%
9000	1	< 0.1%
10000	144	0.6%
11357	1	< 0.1%
11854	1	< 0.1%
12000	25	0.1%
12500	1	< 0.1%
13000	22	0.1%

Value	Count	Frequency (%)
1463000	1	< 0.1%
1300000	4	< 0.1%
1143429	1	< 0.1%
1125000	1	< 0.1%
1115000	2	< 0.1%
1000000	1	< 0.1%
975000	1	< 0.1%
963000	1	< 0.1%
920000	1	< 0.1%
891000	2	< 0.1%

numero_creditos
Real number (ℝ)

Distinct	13
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.1631163

Minimum	1
Maximum	15
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	193.8 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	2
Q3	3
95-th percentile	4
Maximum	15
Range	14
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.232528
Coefficient of variation (CV)	0.56979277
Kurtosis	1.6966851
Mean	2.1631163
Median Absolute Deviation (MAD)	1
Skewness	1.0615887
Sum	53615
Variance	1.5191253
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=13)

Value	Count	Frequency (%)
1	9799	39.5%
2	6420	25.9%
3	4743	19.1%
4	2708	10.9%
5	900	3.6%
6	162	0.7%
7	29	0.1%
9	10	< 0.1%
8	7	< 0.1%
12	4	< 0.1%
Other values (3)	4	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	9799	39.5%
2	6420	25.9%
3	4743	19.1%
4	2708	10.9%
5	900	3.6%
6	162	0.7%
7	29	0.1%
8	7	< 0.1%
9	10	< 0.1%
10	2	< 0.1%

Value	Count	Frequency (%)
15	1	< 0.1%
12	4	< 0.1%
11	1	< 0.1%
10	2	< 0.1%
9	10	< 0.1%
8	7	< 0.1%
7	29	0.1%
6	162	0.7%
5	900	3.6%
4	2708	10.9%

antiguedad_entidad
Real number (ℝ)

ZEROS

Distinct	32
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.2287582

Minimum	0
Maximum	49
Zeros	418
Zeros (%)	1.7%
Negative	0
Negative (%)	0.0%
Memory size	193.8 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	2
Q3	5
95-th percentile	8
Maximum	49
Range	49
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	2.6921005
Coefficient of variation (CV)	0.83378822
Kurtosis	11.82301
Mean	3.2287582
Median Absolute Deviation (MAD)	1
Skewness	2.1768567
Sum	80028
Variance	7.2474053
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=32)

Value	Count	Frequency (%)
1	7580	30.6%
2	5156	20.8%
3	3318	13.4%
4	1982	8.0%
5	1678	6.8%
6	1577	6.4%
7	1376	5.6%
8	737	3.0%
0	418	1.7%
9	386	1.6%
Other values (22)	578	2.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	418	1.7%
1	7580	30.6%
2	5156	20.8%
3	3318	13.4%
4	1982	8.0%
5	1678	6.8%
6	1577	6.4%
7	1376	5.6%
8	737	3.0%
9	386	1.6%

Value	Count	Frequency (%)
49	1	< 0.1%
39	1	< 0.1%
38	1	< 0.1%
36	1	< 0.1%
31	1	< 0.1%
29	1	< 0.1%
27	1	< 0.1%
25	3	< 0.1%
23	5	< 0.1%
22	3	< 0.1%

clase
Categorical

IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	193.8 KiB

Bueno	24334
Malo	452

Length

Max length	5
Median length	5
Mean length	4.9817639
Min length	4

Characters and Unicode

Total characters	123478
Distinct characters	8
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Malo
2nd row	Malo
3rd row	Malo
4th row	Malo
5th row	Malo

Common Values

Value	Count	Frequency (%)
Bueno	24334	98.2%
Malo	452	1.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
bueno	24334	98.2%
malo	452	1.8%

Most occurring characters

Value	Count	Frequency (%)
o	24786	20.1%
B	24334	19.7%
u	24334	19.7%
e	24334	19.7%
n	24334	19.7%
M	452	0.4%
a	452	0.4%
l	452	0.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	98692	79.9%
Uppercase Letter	24786	20.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	24786	25.1%
u	24334	24.7%
e	24334	24.7%
n	24334	24.7%
a	452	0.5%
l	452	0.5%

Uppercase Letter

Value	Count	Frequency (%)
B	24334	98.2%
M	452	1.8%

Most occurring scripts

Value	Count	Frequency (%)
Latin	123478	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	24786	20.1%
B	24334	19.7%
u	24334	19.7%
e	24334	19.7%
n	24334	19.7%
M	452	0.4%
a	452	0.4%
l	452	0.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	123478	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	24786	20.1%
B	24334	19.7%
u	24334	19.7%
e	24334	19.7%
n	24334	19.7%
M	452	0.4%
a	452	0.4%
l	452	0.4%

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	cedula	oficina	categoria	tiempo_desembolso	monto	saldo	plazo	tasa	cuota	garantia	diasmora	forma_de_pago	reestructurado	edad	ocupacion	nivel_educativo	ingreso_total	egreso_total	estrato	antiguedad_empresa	estado_civil	sexo	personas	tipo_vivienda	tipo_contrato	aportes	numero_creditos	antiguedad_entidad	clase
0	6754	Santa Fe	E	63	500000.0	411775.0	18	3.1667	36868	P	1784	1	2	30	Empleado	Bachillerato	372315.0	0.0	3	6	Unión Libre	Masculino	0	NaN	NaN	69000.0	1	6	Malo
1	17922	Usaquen	E	65	2000000.0	1563604.0	24	3.2083	120761	P	1758	1	2	38	Empleado	Bachillerato	900000.0	0.0	2	8	Soltero	Masculino	0	NaN	NaN	0.0	1	6	Malo
2	167	Chapinero	E	60	800000.0	658843.0	18	3.1667	58990	P	1677	1	2	57	Empleado	Técnico	800000.0	0.0	4	14	Soltero	Femenino	0	NaN	NaN	82000.0	1	5	Malo
3	23093	Santa Fe	E	57	800000.0	744568.0	21	3.2083	52945	P	1670	1	2	28	Empleado	Bachillerato	325000.0	80000.0	3	8	Casado	Masculino	0	Familiar	Término Indefinido	82000.0	1	5	Malo
4	16530	Chapinero	E	58	14153655.0	13567368.0	48	2.8750	547318	R	1621	1	2	46	Independiente	Universitario	2500000.0	1500000.0	5	0	Casado	Masculino	2	Propia	NaN	300000.0	1	7	Malo
5	23667	Usaquen	E	62	1000000.0	569689.0	18	3.1667	73737	P	1587	1	2	38	Empleado	Bachillerato	401280.0	167000.0	3	5	Separado	Femenino	0	Familiar	Término Indefinido	69000.0	1	7	Malo
6	22882	Santa Fe	E	52	1500000.0	1168465.0	15	3.3000	128392	P	1440	1	2	56	Desempleado	Bachillerato	0.0	0.0	3	0	Casado	Masculino	3	Familiar	NaN	95000.0	1	5	Malo
7	15797	Chapinero	E	51	1000000.0	825327.0	18	3.3000	74565	P	1424	1	2	39	Empleado	Tecnológico	410000.0	0.0	3	9	Soltero	Femenino	0	NaN	NaN	0.0	1	5	Malo
8	22336	Usme	E	54	10000000.0	9931812.0	120	2.1742	247418	R	1416	1	2	46	Independiente	Bachillerato	1200000.0	0.0	3	0	Casado	Masculino	0	NaN	NaN	200000.0	1	5	Malo
9	5403	Usaquen	E	61	9642432.0	6980780.0	36	2.8333	430745	R	1407	1	2	44	Independiente	Bachillerato	1600000.0	0.0	2	0	Unión Libre	Femenino	0	NaN	NaN	373900.0	2	7	Malo

	cedula	oficina	categoria	tiempo_desembolso	monto	saldo	plazo	tasa	cuota	garantia	forma_de_pago	reestructurado	edad	ocupacion	nivel_educativo	ingreso_total	egreso_total	estrato	antiguedad_empresa	estado_civil	sexo	personas	tipo_vivienda	tipo_contrato	aportes	numero_creditos	antiguedad_entidad	clase
24776	14	Usaquen	A	5	1600000.0	1211941.0	18	2.1742	108426	P	2	2	22	Empleado	Tecnológico	415000.0	100000.0	2	1	Soltero	Masculino	1	Familiar	Término Definido	15500.0	1	1	Bueno
24777	13	Usme	A	8	1200000.0	867291.0	24	2.1742	64761	P	1	2	37	Independiente	Ninguno	846000.0	350000.0	1	0	Unión Libre	Masculino	5	Arrendada	Término Indefinido	155000.0	3	7	Bueno
24778	12	Usme	A	3	1600000.0	1413681.0	21	2.1742	95746	P	1	2	27	Empleado	Bachillerato	609000.0	80008.0	4	2	Soltero	Masculino	0	Familiar	Término Definido	15500.0	1	1	Bueno
24779	11	Usaquen	A	2	6000000.0	5774787.0	36	2.1742	242048	P	1	2	32	Independiente	Bachillerato	2450000.0	1500000.0	3	0	Casado	Masculino	2	Familiar	NaN	212000.0	4	4	Bueno
24780	10	Usaquen	A	5	1500000.0	1243988.0	30	2.1700	67312	P	2	2	36	Empleado	Bachillerato	670000.0	350000.0	2	8	Casado	Masculino	3	Propia	Término Indefinido	21500.0	3	2	Bueno
24781	7	Usaquen	A	20	6000000.0	2719389.0	36	2.0000	210640	P	2	2	38	Empleado	Bachillerato	1200000.0	500000.0	3	11	Casado	Masculino	3	Familiar	Término Indefinido	6000.0	1	2	Bueno
24782	6	Bosa	A	8	12000000.0	10726957.0	48	2.0834	397891	R	1	2	39	Empleado	Universitario	5741200.0	2170147.0	6	7	Unión Libre	Masculino	1	Familiar	Término Indefinido	131000.0	3	4	Bueno
24783	5	Tunjuelito	A	14	2000000.0	966688.0	24	2.1742	108602	P	1	2	38	Empleado	Universitario	1047000.0	200000.0	3	8	Soltero	Masculino	0	Propia	Término Indefinido	0.0	3	7	Bueno
24784	4	Santa Fe	A	5	900000.0	684264.0	18	2.1742	60991	P	1	2	39	Empleado	Bachillerato	309000.0	0.0	3	11	Soltero	Masculino	0	NaN	Término Indefinido	0.0	1	1	Bueno
24785	3	Usaquen	A	3	600000.0	464362.0	12	2.1742	57366	P	1	2	30	Empleado	Tecnológico	806000.0	533600.0	3	3	Casado	Masculino	2	Arrendada	Término Indefinido	15500.0	1	1	Bueno

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator